Oracle Security Management

Oracle manages database access permissions using users and roles. Users own schema objects (for example, tables, views) and can assign privileges on those objects to other users to control who has access to which objects.

Navicat provides User toadd, duplicate, edit, delete users/roles, grant/revoke server privileges and privileges on the selected schema objects. The object pane displays all the users/roles that exist in the server.

In addition to the user accounts that you create, the database includes a number of user accounts that are automatically created upon installation. Administrative accounts: SYS, SYSTEM, SYSMAN, and DBSNMP. Administrative accounts are highly privileged accounts to perform administrative tasks such as starting and stopping the database, managing database memory and storage, creating and managing database users, and so on. Your database may also include sample schemas (SCOTT, HR, OE, OC, PM, IX and SH), which are a set of interlinked schemas that enable Oracle documentation and Oracle instructional materials to illustrate common database tasks.

Manager User

Just simply click -> User to open an object pane for User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete users.

Add User

To add a new user

Duplicate User

To create a new user with modification as one of the existing users

Edit User

To edit an existing user

Delete User

To delete a user

Manage Role

Just simply click -> Role to open an object pane for Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete roles.

Add Role

To add a new role

Duplicate Role

To create a new role with modification as one of the existing rolers

Edit Role

To edit an existing role

Delete Role

To delete a role

Privilege Manager

To edit privilege according to the database objects by using Privilege Manager